Executive Summary
R1
Last Update
2022-08-20 13:41:50
Total Sales
$2,261,537
Total Orders
9,800
Average Sales per Order
$231
R1
Product Type
Product Sales
R1
Best Sellers
Furniture
R2
Sales Analysis (2015 - 2018)
Furniture
Total Sales
$728,658.6
Proportion of Grand Total Sales
2015 Total Sales
$156,478
2016 Total Sales
$164,054
2017 Total Sales
$195,813
2018 Total Sales
$212,313
R2 {data-height = 350}
Daily Sales
Daily Sales (Log)
Monthly Sales
R2 {data-height = 650}
Difference Plot
Seasonal Plot
Subseries Plot
Furniture Forecast {data-orientation=columns}
ETS Forecast of Next 24 Months
Model Summary
Forecast method: ETS(M,N,M)
Model Information:
ETS(M,N,M)
Call:
ets(y = furni.ts)
Smoothing parameters:
alpha = 0.1285
gamma = 1e-04
Initial states:
l = 14423.7702
s = 1.9561 1.8814 0.8823 1.6921 0.7104 0.834
0.8305 0.8466 0.709 0.7855 0.3 0.5721
sigma: 0.2949
AIC AICc BIC
988.0957 1003.0957 1016.1637
Error measures:
ME RMSE MAE MPE MAPE MASE ACF1
Training set 734.9213 3049.649 2534.17 -2.732487 21.12099 0.6876885 -0.1613837
Forecasts:
Point Forecast Lo 95 Hi 95
Jan 2019 10207.425 4307.867 16106.983
Feb 2019 5353.166 2231.588 8474.745
Mar 2019 14014.336 5770.408 22258.265
Apr 2019 12649.974 5144.303 20155.644
May 2019 15105.678 6066.680 24144.676
Jun 2019 14817.456 5876.629 23758.283
Jul 2019 14879.544 5827.155 23931.934
Aug 2019 12675.272 4901.215 20449.329
Sep 2019 30191.470 11525.935 48857.005
Oct 2019 15742.182 5932.900 25551.464
Nov 2019 33568.911 12488.574 54649.248
Dec 2019 34900.392 12815.672 56985.112
Jan 2020 10207.437 3699.259 16715.615
Feb 2020 5353.173 1914.540 8791.805
Mar 2020 14014.352 4945.833 23082.872
Apr 2020 12649.988 4404.798 20895.179
May 2020 15105.695 5189.206 25022.185
Jun 2020 14817.473 5021.251 24613.694
Jul 2020 14879.562 4973.446 24785.677
Aug 2020 12675.286 4178.349 21172.224
Sep 2020 30191.505 9814.311 50568.698
Oct 2020 15742.200 5045.632 26438.768
Nov 2020 33568.950 10607.378 56530.521
Dec 2020 34900.432 10870.878 58929.986Model Diagnostic
Ljung-Box test
data: Residuals from ETS(M,N,M)
Q* = 31.017, df = 3, p-value = 8.431e-07
Model df: 14. Total lags used: 17